Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# EXTLINES

The EXTLINES function extracts lines from a multiline text expression.

Return Value

`TEXT` or `NTEXT`

Syntax

EXTLINES(text-expression [start [numlines]])

Arguments

text-expression

  A multiline `TEXT` or `NTEXT` expression from whose values one or more lines are to be extracted.

start

  An `INTEGER` that represents the line number at which to begin extracting. The position of the first line in text-expression is `1`. When you omit this argument, EXTLINES begins with line 1.

numlines

  An `INTEGER` representing the number of lines to be extracted. When you do not specify numlines, or when you specify a number greater than the number of lines from start to the end of text-expression, all the lines from start to the end of text-expression are copied.

Examples

Example 12-8 Extracting One Text Line

This example shows how to extract the second line from a multiline text value in a variable called `mktglist`. The `mktglist` variable has the following values.

    Salespeople
    Products
    Services

The statement

    SHOW EXTLINES(mktglist 2 1)

produces the following output.

    Products